{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Mod'Op","Fiche organisateur N1","Fiche organisateur N2","Rapport de Concours","00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","Memo"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mod'Op","index":0,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[5,1,5,8],[7,1,7,8],[1,2,1,8],[2,2,2,8]]}
[]
[null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,"Président : Monsieur Jean Paul Kerihuel - 7, Allée Mme de La Fayette - 29 200 - ST RENAN",null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[]
[]
[null,"Concours Ovin inter-races NIVEAU 1"]
[]
[null,"Comment utiliser ce fichier ? "]
[]
[null,"Attention"]
[null,"Ce fichier est conçu pour la gestion des concours Inter-races sur ovins de NIVEAU 1 uniquement ! "]
[]
[null,"1. Phase préparatoire"]
[]
[null,"Dans l'onglet \"Fiche Organisateur N°1\" => compléter les cases grises. "]
[]
[null,"Dans l'onglet \"Fiche Organisateur N°2\" => compléter les cases grises (voir recommendation au bas de la feuille). "]
[]
[null,"Dans l'onglet \"00\" => compléter les cases gris clair sous le contrôle du juge :  "]
[null," => liste des épreuves"]
[null," => pointages attribués (entrer le chiffre simple, la barre de fraction se met automatiquement)"]
[null,"Le concours niveau 1 est sur 75 points. La répartition des points entre les épreuves et l'intelligence de"]
[null,"l'exécution est à l'appréciation de chaque juge. Compléter la case (bleue) de l'onglet \"00\" en conséquence. "]
[null,"Si le pointage total n'est pas de 75 points, un message \"ATTENTION : TOTAL non égal à 75\" apparaît. "]
[null,"Sinon, le message est \"TOTAL = OK\" "]
[]
[null,"2. Phase de concours"]
[]
[null,"Imprimer la feuille (vierge) du concurrent qui doit passer et la donner au juge pour son brouillon. "]
[]
[null,"Pendant le passage du concurrent, le juge renseigne les cases en gris clair et gris foncé. "]
[]
[null,"Lorsque le concurrent est passé, le juge remet au secrétariat cette feuille de pointage manuscrite renseignée. "]
[null,"Le secrétariat retranscrit dans Excel (dans le bon onglet ! ) les pointages sur la feuille du concurrent "]
[null,"ATTENTION : bien vérifier que les noms du concurrent et du chien correspondent ! "]
[]
[null,"Pendant le déroulement du concours, les tableaux des onglets \"Fiche Organisateur N°2\" et \"Rapport de "]
[null,"concours\" se mettent à jour automatiquement en temps réel. "]
[]
[null,"Pendant le déroulement du concours, il est possible de mettre à jour le classement en appuyant sur le "]
[null,"bouton \"CLASSER\" (Attention : il est possible que le bouton ne fonctionne pas sous open Office). "]
[]
[null,"3. Fin du concours"]
[]
[null,"Lorsque toutes les feuilles sont saisies, le rapport du concours doit donc être à jour. "]
[null,"Il ne reste qu'à appuyer sur le bouton \"CLASSER\" pour que les lignes de concurrents soient dans l'ordre "]
[null,"croissant des résultats. "]
[]
[null,"ATTENTION CEPENDANT : ne pas faire une confiance aveugle à l'informatique ! "]
[null," => vérifier la cohérence des chiffres et sonder quelques feuilles pour détecter d'éventuelles erreurs…"]
[]
[null,"La cellule \"Observations\" du \"Rapport de concours\" doit être renseignée par le juge. "]
[null,"Il peut le faire manuellement après impression de la feuille."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Note : CC = Centrale Canine (ex-SCC) "]
[null,"Lorsque tout est OK, éditer les feuilles pour le juge, la CC et les concurrents…"]

{"sheet":"Fiche organisateur N1","index":1,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[9,2,9,8],[1,2,1,8],[2,2,2,8],[7,2,7,8]]}
[]
[null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,"Président : Monsieur Jean Paul Kerihuel - 7, Allée Mme de La Fayette - 29 200 - ST RENAN",null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pour fonctionner correctement ce fichier nécessite EXCEL avec prise"]
[null,null,null,null,null,null,null,null,null,null,null,null,"en compte des macros"]
[]
[null,null,"Concours Inter race Ovin"]
[]
[null,null,"Organisateur ==> Fiche N°1"]
[]
[]
[null,null,null,"Date : ",null,null," [ JJ.MM.AAAA ]"]
[null,null,null,"ORGANISATEUR : "]
[null,null,null,"Lieu :  "]
[null,null,null,"Contact : "]
[null,null,null,"Coordonnées du contact : "]
[null,null,null,"E-mail : "]
[null,null,null,"Tél. : "]
[null,null,null,"Adresse du rassemblement : "]
[null,null,null,"Juge : "]
[]
[]
[]
[]
[]
[null,null,null,"Concours : ","Niveau 1"]

{"sheet":"Fiche organisateur N2","index":2,"n_rows":38,"n_cols":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[[39,2,39,10],[7,7,7,8],[0,3,0,12],[3,3,3,12],[13,1,13,12],[1,3,1,12],[37,3,37,11]]}
[null,null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,null,"Président : Monsieur Jean Paul Kerihuel - 7, Allée Mme de La Fayette - 29 200 - ST RENAN"]
[]
[null,null,null,"Concours Inter race Ovin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MODE D'EMPLOI"]
[null,null,null,null,"ORGANISATEUR",{"$f":"'Fiche organisateur N1'!E14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"1. Copier/coller dans la zone orangée le catalogue issu du fichier de la SCC"]
[null,null,null,null,"Lieu ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"2. Cliquer sur la bouton : \"Formatage catalogue\""]
[null,null,null,null,"Adresse du rassemblement",{"$f":"'Fiche organisateur N1'!E20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"3. Mettre les N° du tirage au sort des chiens dans les cases de la colonne P"]
[null,null,null,null,null,null,"Date du concours :",{"$f":"IF('Fiche organisateur N1'!E13=\"\",\"-\",'Fiche organisateur N1'!E13)","v":"-"},null,null,null,null,null,null,null,null,null,null,"4. Cliquer sur le bouton :  \"Trier et Copier\""]
[null,null,null,null,"Contact",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[null,null,null,null,"Coordonnées du Contact",{"$f":"'Fiche organisateur N1'!E17","v":0}]
[null,null,null,null,"Email",{"$f":"'Fiche organisateur N1'!E18","v":0}]
[null,null,null,null,"Tel ",{"$f":"'Fiche organisateur N1'!E19","v":0},null,null,null,null,null,null,null,null,null,null,"(Vous pouvez également remplir manuellement les colonnes grises de la fiche organisateur si vous le souhaitez)"]
[]
[null,"Organisateur ==> Fiche  N°2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    METTRE LE TIRAGE AU SORT DANS CETTE COLONNE"]
[null,"N°","Propriétaires","Conducteurs","Noms des Chiens","Affixe","Races + Sexe","N° FAPAC","Identifiants","N° Carnet de Travail","Points ","Qualificatifs","Classement",null,null,null,"NOM DU CHIEN","AFFIXE","RACE SEXE","FAPAC","IDENTIFIANT","CT","PROPRIETAIRE","CONDUCTEUR"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"'01'!C36","v":"-"},{"$f":"'01'!F36","v":"-"},{"$f":"IF(K17=\"-\",\"X\",IF(K17=0,\"N.C.\",RANK(K17,$K$17:$K$34,0)))","v":"X"}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"'02'!C36","v":"-"},{"$f":"'02'!F36","v":"-"},{"$f":"IF(K18=\"-\",\"X\",IF(K18=0,\"N.C.\",RANK(K18,$K$17:$K$34,0)))","v":"X"}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"'03'!C36","v":"-"},{"$f":"'03'!F36","v":"-"},"X"]
[null,4,null,null,null,null,null,null,null,null,{"$f":"'04'!C36","v":"-"},{"$f":"'04'!F36","v":"-"},"X"]
[null,5,null,null,null,null,null,null,null,null,{"$f":"'05'!C36","v":"-"},{"$f":"'05'!F36","v":"-"},"X"]
[null,6,null,null,null,null,null,null,null,null,{"$f":"'06'!C36","v":"-"},{"$f":"'06'!F36","v":"-"},"X"]
[null,7,null,null,null,null,null,null,null,null,{"$f":"'07'!C36","v":"-"},{"$f":"'07'!F36","v":"-"},"X"]
[null,8,null,null,null,null,null,null,null,null,{"$f":"'08'!C36","v":"-"},{"$f":"'08'!F36","v":"-"},"X"]
[null,9,null,null,null,null,null,null,null,null,{"$f":"'09'!C36","v":"-"},{"$f":"'09'!F36","v":"-"},"X"]
[null,10,null,null,null,null,null,null,null,null,{"$f":"'10'!C36","v":"-"},{"$f":"'10'!F36","v":"-"},"X"]
[null,11,null,null,null,null,null,null,null,null,{"$f":"'11'!C36","v":"-"},{"$f":"'11'!F36","v":"-"},"X"]
[null,12,null,null,null,null,null,null,null,null,{"$f":"'12'!C36","v":"-"},{"$f":"'12'!F36","v":"-"},"X"]
[null,13,null,null,null,null,null,null,null,null,{"$f":"'13'!C36","v":"-"},{"$f":"'13'!F36","v":"-"},"X"]
[null,14,null,null,null,null,null,null,null,null,{"$f":"'14'!C36","v":"-"},{"$f":"'14'!F36","v":"-"},"X"]
[null,15,null,null,null,null,null,null,null,null,{"$f":"'15'!C36","v":"-"},{"$f":"'15'!F36","v":"-"},"X"]
[null,16,null,null,null,null,null,null,null,null,{"$f":"'16'!C36","v":"-"},{"$f":"'16'!F36","v":"-"},"X"]
[null,17,null,null,null,null,null,null,null,null,{"$f":"'17'!C36","v":"-"},{"$f":"'17'!F36","v":"-"},"X"]
[null,18,null,null,null,null,null,null,null,null,{"$f":"'18'!C36","v":"-"},{"$f":"'18'!F36","v":"-"},"X"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D17:D34)","v":0}]
[null,null,null,"NE  PAS  UTILISER  CETTE  FICHE  COMME  RAPPORT  DE  CONCOURS  ! "]

{"sheet":"Rapport de Concours","index":3,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[[43,1,43,13],[0,3,0,12],[1,3,1,12],[3,3,3,12],[4,11,4,12],[13,1,13,12]]}
[null,null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,null,"Président : Monsieur Jean Paul Kerihuel - 7, Allée Mme de La Fayette - 29 200 - ST RENAN"]
[]
[null,null,null,"Concours Inter race Ovin",null,null,null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[null,null,null,null,null,null,"ORGANISATEUR",{"$f":"'Fiche organisateur N1'!E14","v":0},null,null,"Date du concours :",{"$f":"IF('Fiche organisateur N1'!E13=\"\",\"-\",'Fiche organisateur N1'!E13)","v":"-"}]
[null,null,null,null,null,null,"Lieu ",{"$f":"'Fiche organisateur N1'!E15","v":0}]
[null,null,null,null,null,null,"Adresse du rassemblement",{"$f":"'Fiche organisateur N1'!E20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note : sur cette feuille, vous pouvez ajuster les largeurs de colonnes…"]
[null,null,null,null,null,null,"Contact",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[null,null,null,null,null,null,"Coordonnées du Contact",{"$f":"'Fiche organisateur N1'!E17","v":0},null,null,null,null,null,null,null,"Appuyer sur le bouton \"CLASSER\" pour classer les chiens dans l'ordre d'arrivée "]
[null,null,null,null,null,null,"Email",{"$f":"'Fiche organisateur N1'!E18","v":0},null,null,null,null,null,null,null,"(opération irréversible)"]
[null,null,null,null,null,null,"Tel ",{"$f":"'Fiche organisateur N1'!E19","v":0}]
[]
[null,"RAPPORT DE CONCOURS => NIVEAU 1"]
[]
[null,null,"Propriétaires","Conducteurs","Noms des chiens","Affixes","Races + Sexe","N° FAPAC","Identifiants","N° Carnets de travail","Résultats","Qualif.1","Classement"]
[null,{"$f":"IF(M17=\"X\",\"-\",M17)","v":"-"},{"$f":"'Fiche organisateur N2'!C17","v":0},{"$f":"'Fiche organisateur N2'!D17","v":0},{"$f":"'Fiche organisateur N2'!E17","v":0},{"$f":"'Fiche organisateur N2'!F17","v":0},{"$f":"'Fiche organisateur N2'!G17","v":0},{"$f":"'Fiche organisateur N2'!H17","v":0},{"$f":"'Fiche organisateur N2'!I17","v":0},{"$f":"'Fiche organisateur N2'!J17","v":0},{"$f":"'Fiche organisateur N2'!K17","v":"-"},{"$f":"'Fiche organisateur N2'!L17","v":"-"},{"$f":"'Fiche organisateur N2'!M17","v":"X"}]
[null,{"$f":"IF(M18=\"X\",\"-\",M18)","v":"-"},{"$f":"'Fiche organisateur N2'!C18","v":0},{"$f":"'Fiche organisateur N2'!D18","v":0},{"$f":"'Fiche organisateur N2'!E18","v":0},{"$f":"'Fiche organisateur N2'!F18","v":0},{"$f":"'Fiche organisateur N2'!G18","v":0},{"$f":"'Fiche organisateur N2'!H18","v":0},{"$f":"'Fiche organisateur N2'!I18","v":0},{"$f":"'Fiche organisateur N2'!J18","v":0},{"$f":"'Fiche organisateur N2'!K18","v":"-"},{"$f":"'Fiche organisateur N2'!L18","v":"-"},{"$f":"'Fiche organisateur N2'!M18","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C19","v":0},{"$f":"'Fiche organisateur N2'!D19","v":0},{"$f":"'Fiche organisateur N2'!E19","v":0},{"$f":"'Fiche organisateur N2'!F19","v":0},{"$f":"'Fiche organisateur N2'!G19","v":0},{"$f":"'Fiche organisateur N2'!H19","v":0},{"$f":"'Fiche organisateur N2'!I19","v":0},{"$f":"'Fiche organisateur N2'!J19","v":0},{"$f":"'Fiche organisateur N2'!K19","v":"-"},{"$f":"'Fiche organisateur N2'!L19","v":"-"},{"$f":"'Fiche organisateur N2'!M19","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C20","v":0},{"$f":"'Fiche organisateur N2'!D20","v":0},{"$f":"'Fiche organisateur N2'!E20","v":0},{"$f":"'Fiche organisateur N2'!F20","v":0},{"$f":"'Fiche organisateur N2'!G20","v":0},{"$f":"'Fiche organisateur N2'!H20","v":0},{"$f":"'Fiche organisateur N2'!I20","v":0},{"$f":"'Fiche organisateur N2'!J20","v":0},{"$f":"'Fiche organisateur N2'!K20","v":"-"},{"$f":"'Fiche organisateur N2'!L20","v":"-"},{"$f":"'Fiche organisateur N2'!M20","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C21","v":0},{"$f":"'Fiche organisateur N2'!D21","v":0},{"$f":"'Fiche organisateur N2'!E21","v":0},{"$f":"'Fiche organisateur N2'!F21","v":0},{"$f":"'Fiche organisateur N2'!G21","v":0},{"$f":"'Fiche organisateur N2'!H21","v":0},{"$f":"'Fiche organisateur N2'!I21","v":0},{"$f":"'Fiche organisateur N2'!J21","v":0},{"$f":"'Fiche organisateur N2'!K21","v":"-"},{"$f":"'Fiche organisateur N2'!L21","v":"-"},{"$f":"'Fiche organisateur N2'!M21","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C22","v":0},{"$f":"'Fiche organisateur N2'!D22","v":0},{"$f":"'Fiche organisateur N2'!E22","v":0},{"$f":"'Fiche organisateur N2'!F22","v":0},{"$f":"'Fiche organisateur N2'!G22","v":0},{"$f":"'Fiche organisateur N2'!H22","v":0},{"$f":"'Fiche organisateur N2'!I22","v":0},{"$f":"'Fiche organisateur N2'!J22","v":0},{"$f":"'Fiche organisateur N2'!K22","v":"-"},{"$f":"'Fiche organisateur N2'!L22","v":"-"},{"$f":"'Fiche organisateur N2'!M22","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C23","v":0},{"$f":"'Fiche organisateur N2'!D23","v":0},{"$f":"'Fiche organisateur N2'!E23","v":0},{"$f":"'Fiche organisateur N2'!F23","v":0},{"$f":"'Fiche organisateur N2'!G23","v":0},{"$f":"'Fiche organisateur N2'!H23","v":0},{"$f":"'Fiche organisateur N2'!I23","v":0},{"$f":"'Fiche organisateur N2'!J23","v":0},{"$f":"'Fiche organisateur N2'!K23","v":"-"},{"$f":"'Fiche organisateur N2'!L23","v":"-"},{"$f":"'Fiche organisateur N2'!M23","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C24","v":0},{"$f":"'Fiche organisateur N2'!D24","v":0},{"$f":"'Fiche organisateur N2'!E24","v":0},{"$f":"'Fiche organisateur N2'!F24","v":0},{"$f":"'Fiche organisateur N2'!G24","v":0},{"$f":"'Fiche organisateur N2'!H24","v":0},{"$f":"'Fiche organisateur N2'!I24","v":0},{"$f":"'Fiche organisateur N2'!J24","v":0},{"$f":"'Fiche organisateur N2'!K24","v":"-"},{"$f":"'Fiche organisateur N2'!L24","v":"-"},{"$f":"'Fiche organisateur N2'!M24","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C25","v":0},{"$f":"'Fiche organisateur N2'!D25","v":0},{"$f":"'Fiche organisateur N2'!E25","v":0},{"$f":"'Fiche organisateur N2'!F25","v":0},{"$f":"'Fiche organisateur N2'!G25","v":0},{"$f":"'Fiche organisateur N2'!H25","v":0},{"$f":"'Fiche organisateur N2'!I25","v":0},{"$f":"'Fiche organisateur N2'!J25","v":0},{"$f":"'Fiche organisateur N2'!K25","v":"-"},{"$f":"'Fiche organisateur N2'!L25","v":"-"},{"$f":"'Fiche organisateur N2'!M25","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C26","v":0},{"$f":"'Fiche organisateur N2'!D26","v":0},{"$f":"'Fiche organisateur N2'!E26","v":0},{"$f":"'Fiche organisateur N2'!F26","v":0},{"$f":"'Fiche organisateur N2'!G26","v":0},{"$f":"'Fiche organisateur N2'!H26","v":0},{"$f":"'Fiche organisateur N2'!I26","v":0},{"$f":"'Fiche organisateur N2'!J26","v":0},{"$f":"'Fiche organisateur N2'!K26","v":"-"},{"$f":"'Fiche organisateur N2'!L26","v":"-"},{"$f":"'Fiche organisateur N2'!M26","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C27","v":0},{"$f":"'Fiche organisateur N2'!D27","v":0},{"$f":"'Fiche organisateur N2'!E27","v":0},{"$f":"'Fiche organisateur N2'!F27","v":0},{"$f":"'Fiche organisateur N2'!G27","v":0},{"$f":"'Fiche organisateur N2'!H27","v":0},{"$f":"'Fiche organisateur N2'!I27","v":0},{"$f":"'Fiche organisateur N2'!J27","v":0},{"$f":"'Fiche organisateur N2'!K27","v":"-"},{"$f":"'Fiche organisateur N2'!L27","v":"-"},{"$f":"'Fiche organisateur N2'!M27","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C28","v":0},{"$f":"'Fiche organisateur N2'!D28","v":0},{"$f":"'Fiche organisateur N2'!E28","v":0},{"$f":"'Fiche organisateur N2'!F28","v":0},{"$f":"'Fiche organisateur N2'!G28","v":0},{"$f":"'Fiche organisateur N2'!H28","v":0},{"$f":"'Fiche organisateur N2'!I28","v":0},{"$f":"'Fiche organisateur N2'!J28","v":0},{"$f":"'Fiche organisateur N2'!K28","v":"-"},{"$f":"'Fiche organisateur N2'!L28","v":"-"},{"$f":"'Fiche organisateur N2'!M28","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C29","v":0},{"$f":"'Fiche organisateur N2'!D29","v":0},{"$f":"'Fiche organisateur N2'!E29","v":0},{"$f":"'Fiche organisateur N2'!F29","v":0},{"$f":"'Fiche organisateur N2'!G29","v":0},{"$f":"'Fiche organisateur N2'!H29","v":0},{"$f":"'Fiche organisateur N2'!I29","v":0},{"$f":"'Fiche organisateur N2'!J29","v":0},{"$f":"'Fiche organisateur N2'!K29","v":"-"},{"$f":"'Fiche organisateur N2'!L29","v":"-"},{"$f":"'Fiche organisateur N2'!M29","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C30","v":0},{"$f":"'Fiche organisateur N2'!D30","v":0},{"$f":"'Fiche organisateur N2'!E30","v":0},{"$f":"'Fiche organisateur N2'!F30","v":0},{"$f":"'Fiche organisateur N2'!G30","v":0},{"$f":"'Fiche organisateur N2'!H30","v":0},{"$f":"'Fiche organisateur N2'!I30","v":0},{"$f":"'Fiche organisateur N2'!J30","v":0},{"$f":"'Fiche organisateur N2'!K30","v":"-"},{"$f":"'Fiche organisateur N2'!L30","v":"-"},{"$f":"'Fiche organisateur N2'!M30","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C31","v":0},{"$f":"'Fiche organisateur N2'!D31","v":0},{"$f":"'Fiche organisateur N2'!E31","v":0},{"$f":"'Fiche organisateur N2'!F31","v":0},{"$f":"'Fiche organisateur N2'!G31","v":0},{"$f":"'Fiche organisateur N2'!H31","v":0},{"$f":"'Fiche organisateur N2'!I31","v":0},{"$f":"'Fiche organisateur N2'!J31","v":0},{"$f":"'Fiche organisateur N2'!K31","v":"-"},{"$f":"'Fiche organisateur N2'!L31","v":"-"},{"$f":"'Fiche organisateur N2'!M31","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C32","v":0},{"$f":"'Fiche organisateur N2'!D32","v":0},{"$f":"'Fiche organisateur N2'!E32","v":0},{"$f":"'Fiche organisateur N2'!F32","v":0},{"$f":"'Fiche organisateur N2'!G32","v":0},{"$f":"'Fiche organisateur N2'!H32","v":0},{"$f":"'Fiche organisateur N2'!I32","v":0},{"$f":"'Fiche organisateur N2'!J32","v":0},{"$f":"'Fiche organisateur N2'!K32","v":"-"},{"$f":"'Fiche organisateur N2'!L32","v":"-"},{"$f":"'Fiche organisateur N2'!M32","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C33","v":0},{"$f":"'Fiche organisateur N2'!D33","v":0},{"$f":"'Fiche organisateur N2'!E33","v":0},{"$f":"'Fiche organisateur N2'!F33","v":0},{"$f":"'Fiche organisateur N2'!G33","v":0},{"$f":"'Fiche organisateur N2'!H33","v":0},{"$f":"'Fiche organisateur N2'!I33","v":0},{"$f":"'Fiche organisateur N2'!J33","v":0},{"$f":"'Fiche organisateur N2'!K33","v":"-"},{"$f":"'Fiche organisateur N2'!L33","v":"-"},{"$f":"'Fiche organisateur N2'!M33","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N2'!C34","v":0},{"$f":"'Fiche organisateur N2'!D34","v":0},{"$f":"'Fiche organisateur N2'!E34","v":0},{"$f":"'Fiche organisateur N2'!F34","v":0},{"$f":"'Fiche organisateur N2'!G34","v":0},{"$f":"'Fiche organisateur N2'!H34","v":0},{"$f":"'Fiche organisateur N2'!I34","v":0},{"$f":"'Fiche organisateur N2'!J34","v":0},{"$f":"'Fiche organisateur N2'!K34","v":"-"},{"$f":"'Fiche organisateur N2'!L34","v":"-"},{"$f":"'Fiche organisateur N2'!M34","v":"X"}]
[]
[]
[]
[]
[null,null,null,{"$f":"COUNTA('Fiche organisateur N2'!E17:E34)","v":0},"(= inscrits)"]
[null,null,"Nombre de chiens ",{"$f":"COUNT(K15:K34)","v":0},"(=entrés sur le terrain)",3,{"$f":"D40*F40","v":0}," <====  Montant de la redevance SCC (chèque global à l'ordre de CC/ CUNTRP)  à joindre au présent rapport"]
[null,null,null,{"$f":"COUNT(K15:K34)-COUNTIF(K15:K34,\"=0\")","v":0},"(=ayant un score non nul) "]
[]
[]
[null,"Observations du Juge "]
[]
[null,null,null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0},null,"Signature : "]

{"sheet":"00","index":4,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,37,8],[36,2,36,3],[14,2,14,3],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[14,4,14,8],[36,5,36,6],[35,7,35,8],[35,4,35,6],[34,4,34,8],[0,7,0,8],[3,1,3,8],[15,4,15,8],[2,1,2,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin",null,null,null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Epreuves            ","Pointages / 75",null,"Observations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MISES A JOUR MARS 2018 : "]
[null,null,null,null,{"$f":"IF(AND(B16=\"\",D16<>\"\")=TRUE,\" => indiquer une épreuve ou ôter le pointage\",IF(AND(B16<>\"\",D16=\"\")=TRUE,\" => indiquer un pointage ou ôter l'épreuve\",\"  OK\"))","v":"  OK"},null,null,null,null,null,{"$f":"IF(E16=\"  OK\",1,0)","v":1},null,null,null,null,null,null,null,null," - EXCELLENT obtenu avec ≥ à 80% des points (soit : ≥ 60 / 75) "]
[null,null,null,null,"  OK",null,null,null,null,null,{"$f":"IF(E17=\"  OK\",1,0)","v":1},null,null,null,null,null,null,null,null," - Suppression de « Intelligence de l’exécution »"]
[null,null,null,null,"  OK",null,null,null,null,null,1,null,null,null,null,null,null,null,null," - Ajout de « Activité – douceur - Initiative » noté sur 10 points"]
[null,null,null,null,"  OK",null,null,null,null,null,1,null,null,null,null,null,null,null,null," - Maintien à la disposition du juge d’une note pour le « Déplacement »"]
[null,null,null,null,{"$f":"IF(AND(B20=\"\",D20<>\"\")=TRUE,\" => indiquer une épreuve ou ôter le pointage\",IF(AND(B20<>\"\",D20=\"\")=TRUE,\" => indiquer un pointage ou ôter l'épreuve\",\"  OK\"))","v":"  OK"},null,null,null,null,null,1,null,null,null,null,null,null,null,null," - 3 excellents sont nécessaires pour passer en niveau 2 avec 2 juges différents"]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,{"$f":"IF(AND(B26=\"\",D26<>\"\")=TRUE,\" => indiquer une épreuve ou ôter le pointage\",IF(AND(B26<>\"\",D26=\"\")=TRUE,\" => indiquer un pointage ou ôter l'épreuve\",\"  OK\"))","v":"  OK"},null,null,null,null,null,1]
[null,null,null,null,{"$f":"IF(AND(B27=\"\",D27<>\"\")=TRUE,\" => indiquer une épreuve ou ôter le pointage\",IF(AND(B27<>\"\",D27=\"\")=TRUE,\" => indiquer un pointage ou ôter l'épreuve\",\"  OK\"))","v":"  OK"},null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,{"$f":"IF(E28=\"  OK\",1,0)","v":1}]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1,null,null,null," "]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,null,null,null,null,null,{"$f":"SUM(K16:K32)","v":17}]
[null,"Activité – douceur - Initiative  =>   ",null,10,"  <== pour les niveaux 1 seulement. Note obligatoire sur 10"]
[null,"Vérification total points affectés => "," - ",{"$f":"D33+D34","v":10},{"$f":"IF(OR(D35<75,D35>75)=TRUE,\"ATTENTION : TOTAL non égal à 75\",\"TOTAL = OK\")","v":"ATTENTION : TOTAL non égal à 75"}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J33+J36","v":0}]

{"sheet":"01","index":5,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[15,4,15,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[31,4,31,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[20,4,20,8],[21,4,21,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[34,7,34,8],[32,6,32,8],[34,4,34,6],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C17","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G17","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D17","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H17","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E17","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F17","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I17","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,{"$f":"IF(B26=\"\",\"\",IF(C26>D26,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M17","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"02","index":6,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C18","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G18","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D18","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H18","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E18","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F18","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I18","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M18","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"03","index":7,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C19","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G19","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D19","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H19","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E19","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F19","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I19","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M19","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"04","index":8,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C20","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G20","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D20","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H20","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E20","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F20","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I20","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M20","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"05","index":9,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C21","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G21","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D21","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H21","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E21","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F21","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I21","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M21","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"06","index":10,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C22","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G22","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D22","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H22","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E22","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F22","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I22","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M22","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"07","index":11,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C23","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G23","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D23","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H23","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E23","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F23","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I23","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M23","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"08","index":12,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C24","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G24","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D24","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H24","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E24","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F24","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I24","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M24","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"09","index":13,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C25","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G25","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D25","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H25","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E25","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F25","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I25","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M25","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"10","index":14,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C26","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G26","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D26","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H26","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E26","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F26","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I26","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M26","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"11","index":15,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C27","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G27","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D27","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H27","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E27","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F27","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I27","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M27","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"12","index":16,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C28","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G28","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D28","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H28","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E28","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F28","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I28","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M28","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"13","index":17,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C29","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G29","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D29","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H29","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E29","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F29","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I29","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M29","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"14","index":18,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C30","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G30","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D30","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H30","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E30","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F30","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I30","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M30","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"15","index":19,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C31","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G31","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D31","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H31","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E31","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F31","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I31","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M31","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"16","index":20,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C32","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G32","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D32","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H32","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E32","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F32","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I32","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M32","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"17","index":21,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C33","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G33","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D33","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H33","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E33","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F33","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I33","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M33","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"18","index":22,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8],[15,4,15,8],[16,4,16,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[29,4,29,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[35,2,35,3],[35,5,35,6],[36,2,36,8],[38,6,38,8],[30,4,30,8],[31,4,31,8],[32,6,32,8],[34,4,34,6],[34,7,34,8],[33,4,33,8]]}
[null,null,null,null,null,null,null,"NIVEAU 1"]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,"Concours Inter race Ovin"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N1'!E14","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N1'!E15","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N1'!E16","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N2'!C34","v":0},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N2'!G34","v":0}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N2'!D34","v":0},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N2'!H34","v":0}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N2'!E34","v":0},null,null,"Affixe : ",{"$f":"'Fiche organisateur N2'!F34","v":0}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N2'!I34","v":0},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K33<>17,LEFT('00'!E35,9)=\"ATTENTION\")=TRUE,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"NON VALIDE => corriger la feuille 00 ! ! !"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B26=\" -\",C26<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,{"$f":"IF(AND(B27=\" -\",C27<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C32)","v":0},{"$f":"SUM(D16:D32)","v":0},null,"Temps = "]
[null,"Activité – douceur - Initiative =>   ",null,{"$f":"'00'!D34","v":10},"  <== pour les niveaux 1 seulement. Note obligatoire sur 10",null,null,null,null,null,{"$f":"IF(C34>D34,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,null,null,null,null,"Classement :",null,null,{"$f":"IF(C35=\"\",\"\",IF(C35>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C32)=0,\"-\",C33+C34+C35)","v":"-"},null,"Qualificatif : ",{"$f":"IF(C36=\"-\",\"-\",IF(C36>59.999,\"EXCELLENT\",IF(C36>48.75,\"TRES BON\",IF(C36>41.25,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N2'!M34","v":"X"},{"$f":"'Fiche organisateur N2'!M37","v":0}]
[null,"Observations :  ",null,null,null,null,null,null,null,{"$f":"J33+J35","v":0}]
[]
[null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N1'!E21","v":0}]

{"sheet":"Memo","index":23,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,5],[4,1,4,4],[9,1,9,4],[21,1,21,5],[20,1,20,5],[5,2,5,3],[5,4,5,5],[6,2,6,3],[6,4,6,5],[12,2,12,4],[1,2,1,5],[2,2,2,5],[25,1,25,4],[22,1,22,5],[23,1,23,5],[24,1,24,5]]}
[]
[null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,"Président : Monsieur Jean Paul Kerihuel 7 Allée Mme de La Fayette 29200 ST RENAN",null,null,null,null,null,null,"Chers relecteurs, vous pouvez faire vos remarques dans ce cadre"]
[]
[]
[]
[]
[]
[]
[null,"QUELQUES RAPPELS "]
[]
[]
[null,null,"Niveaux"]
[null,"Qualificatifs","I   / 75","II   / 100","III   / 150",null,null,null,null,"MISES A JOUR MARS 2018 : "]
[null,null,"Débutant","Brevet","Sélectif",null,null,null,null," - EXCELLENT obtenu avec ≥ à 80% des points (soit : ≥ 60 / 75) "]
[null,"Excellent : ","³ 60","³ 80.00","³ 120.0"," <====",null,null,null," - Suppression de « Intelligence de l’exécution »"]
[null,"Très Bon : ","³ 45.00","³ 60.00","³ 90.00",null,null,null,null," - Ajout de « Activité – douceur - Initiative » noté sur 10 points"]
[null,"Bon : ","³ 37.50","³ 50.00","³ 75.00",null,null,null,null," - Maintien à la disposition du juge d’une note pour le « Déplacement »"]
[null,"Sans Qualif. : ","< 37.50","< 50.00","< 75.00",null,null,null,null," - 3 excellents sont nécessaires pour passer en niveau 2 avec 2 juges différents"]
[]
[null,"Pour un même couple conducteur-chien, la participation est limitée à 5 concours par an, et par niveau, au-delà, les résultats ne seront pas pris en compte, même pour le classement. "]
[null,"La classe Travail en Expo. : Le qualificatif « Excellent » en niveau I, donne droit à l’engagement en classe Travail dans les Expositions de Conformité au Standard."]
[null,"Brevet : Le Brevet de Travail sur Troupeaux est décerné après avoir obtenu un minimum de 75 points sur 100, en concours de niveau II sous deux Juges différents. "]
[null," Le Brevet n’est homologué qu’après enregistrement sur le Carnet de travail des deux propositions faites suivant les règles ci-dessus et il est obligatoire pour tout engagement en niveau III."]
[null,"CACT  &  RCACT : Le Certificat d’Aptitude au Championnat de Travail sur troupeaux (C.A.C.T.) et sa Réserve (R.C.A.C.T.) ne peuvent être attribués que dans les concours sélectifs, Championnat de France compris, à condition que les chiens classés premier et deuxième aient obtenu au moins 80 % des points, soit 120 / 150  et qu’il n’y ait pas d’ex-æquo pour les places de premier et de deuxième."]
[null,"               Seul un Juge qualifié peut décerner ces récompenses."]
[null," L’attribution de ces récompenses n’est pas systématique, même si le pointage est conforme, c’est le juge qui apprécie s’il peut les attribuer, au vu du travail qui a été exécuté et qui doit être de qualité exceptionnelle."]